<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>MSF for Agile Software Development</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link href="css/msf.css" type="text/css" rel="stylesheet" />
    <script language="JavaScript" src="CODE/header.js"></script>
    <script language="JavaScript" src="CODE/footer.js"></script>
    <script language="JavaScript" src="CODE/msf.js"></script>

</head>
<body onload="javascript:setCheckboxValue();initOverviewCookie();" marginheight="0"
    marginwidth="0">
    <!-- start header -->
    <table class="idheader" height="70" cellspacing="0" cellpadding="0" width="100%"  border="0">
        <tbody>
            <tr>
                <td width="*">
                    <img height="71" alt="MSF for Agile Software Development" src="images/header_agile.gif" width="400" /></td>
                <td width="115">
                    <img id="vstslogo" height="40" alt="Visual Studio Team System logo" src="images/header_vsts_logo.gif"
                        width="320" /></td>
            </tr>
            <tr bgcolor="#5373ad" height="1">
                <td colspan="2">
                    <img height="1" src="images/clear.gif" width="1" alt="" /></td>
            </tr>
        </tbody>
    </table>
    <!-- end  header -->
    <!-- start breadcrumbs and tabs -->
    <table class="tabrow" height="28" cellspacing="0" cellpadding="0" width="100%" border="0">
        <tbody>
            <tr>
                <td width="164">
                    <img height="1" src="images/clear.gif" width="164" alt="" /></td>
                <td class="bottom">
                    <div id="TabsHTML" style="margin: 0pt">
                        <table cellspacing="0" cellpadding="0" width="100%" border="0" xmlns:msxsl="urn:schemas-microsoft-com:xslt"
                            xmlns:some-prefix="some-uri" xmlns:msxml="urn:schemas-microsoft-com:xslt" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                            xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-10-13T22:49:49"
                            xmlns:mstns="http://tempuri.org/XMLSchema.xsd">
                            <tbody>
                                <tr>
                                    <td class="taboff" width="80"><a class="taboff" onclick="javascript:doLink('Concepts');" href="Concepts.htm">Overview</a></td><td width="6"><img src="images/clear.gif" alt=""/></td>
<td class="taboff" width="80"><a class="taboff" onclick="javascript:doLink('AboutRoles');" href="AboutRoles.htm">Roles</a></td><td width="6"><img src="images/clear.gif" alt=""/></td>
<td class="taboff" width="80"><a class="taboff" onclick="javascript:doLink('AboutWorkItems');" href="AboutWorkItems.htm">Work Items</a></td><td width="6"><img src="images/clear.gif" alt=""/></td>
<td class="taboff" width="80"><a class="taboff" onclick="javascript:doLink('AboutViews');" href="AboutViews.htm">Views</a></td><td width="6"><img src="images/clear.gif" alt=""/></td>
<td class="tabon" width="80"><a class="tabon" onclick="javascript:doLink('WorkStreamsIndex');" href="WorkStreamsIndex.htm">Index</a></td><td width="6"><img src="images/clear.gif" alt=""/></td>

                                    <td align="right">
                                        <div style="margin-top: 3pt">
                                            <p class="p1a">
                                                <a onclick='javascript:open_window1("glossary.htm")' href="#">Glossary</a></p>
                                        </div>
                                    </td>
                                    <td width="38">
                                        <img src="images/clear.gif" alt=""/></td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                    <!-- end tabs -->
                </td>
            </tr>
        </tbody>
    </table>
    <!-- end breadcrumbs and tabs -->
    <!-- start main body table-->
    <table class="bodytable" cellspacing="0" cellpadding="0" width="100%" border="0">
        <tbody>
            <tr>
                <!-- start left column with navigation -->
                <td width="140">
                    <div id="leftside">
                        <div id="sidemenuHTML">
                            <div style="margin: 6px 0px 5px 20px" xmlns:msxsl="urn:schemas-microsoft-com:xslt"
                                xmlns:some-prefix="some-uri" xmlns:msxml="urn:schemas-microsoft-com:xslt" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                                xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-10-13T22:49:49"
                                xmlns:mstns="http://tempuri.org/XMLSchema.xsd">
                                <p class="p1a">
                                    <a class="nav" onclick="javascript:doPortal('click')" href="#">Project Portal<img
                                        height="9" alt="link arrow" src="images/right-arrow.gif" width="9" border="0" /></a></p>
                            </div>
                            <table cellspacing="0" cellpadding="0" width="140" border="0" xmlns:msxsl="urn:schemas-microsoft-com:xslt"
                                xmlns:some-prefix="some-uri" xmlns:msxml="urn:schemas-microsoft-com:xslt" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                                xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-10-13T22:49:49"
                                xmlns:mstns="http://tempuri.org/XMLSchema.xsd">
                                <tbody>
                                    <tr>
                                        <td width="12">
                                            <img height="12" src="images/b_nav_topleft.gif" width="12" alt="" /></td>
                                        <td class="leftnavtop">
                                            <img src="images/clear.gif" alt="" /></td>
                                        <td width="1" background="images/dots.gif" rowspan="3">
                                            <img src="images/dots.gif" alt="" /></td>
                                    </tr>
                                    <tr>
                                        <td background="images/b_nav_left.gif">
                                            <img src="images/b_nav_left.gif" alt=""/>
                                        </td>
                                        <td class="leftnavtable">
                                            <table cellspacing="0" cellpadding="0" width="100%" border="0">
                                                <tbody>
                                                    <tr><td class="nav-off"><a class="nav" onclick="javascript:doLink('WorkStreamsIndex');" href="WorkStreamsIndex.htm">Work Streams</a></td></tr>
<tr><td class="nav-select"><a class="nav" onclick="javascript:doLink('ActivitiesIndex');" href="ActivitiesIndex.htm">Activities</a></td></tr>
<tr><td class="nav-off"><a class="nav" onclick="javascript:doLink('WorkItemsIndex');" href="WorkItemsIndex.htm">Work Items</a></td></tr>
<tr><td class="nav-off"><a class="nav" onclick="javascript:doLink('WorkProductsIndex');" href="WorkProductsIndex.htm">Work Products</a></td></tr>
<tr><td class="nav-off"><a class="nav" onclick="javascript:doLink('ReportsIndex');" href="ReportsIndex.htm">Reports</a></td></tr>
<tr><td class="nav-off"><a class="nav" onclick="javascript:doLink('QueriesIndex');" href="QueriesIndex.htm">Queries</a></td></tr>
<tr><td class="nav-off"><a class="nav" onclick="javascript:doLink('HowtoIndex');" href="HowtoIndex.htm">How To's</a></td></tr>

                                                </tbody>
                                            </table>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            <img src="images/b_nav_bottomleft.gif" alt="" /></td>
                                        <td class="leftnavbottom">
                                            <img src="images/clear.gif" alt="" /></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                        <!-- start left column see also area -->
                        <div id="SeeAlsoHTML">
                            <!-- start left column see also area --><div id="SeeAlsoHTML"><table class="seealso" cellSpacing="0" cellPadding="0" width="134" border="0"  xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:some-prefix="some-uri" xmlns:msxml="urn:schemas-microsoft-com:xslt" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-10-13T22:49:49"  xmlns:mstns="http://tempuri.org/XMLSchema.xsd" ><tbody><tr><td width="13"><img src="images/b_see_topleft.gif"  alt=""/></td><td class="seealso_top"><img src="images/clear.gif"  alt=""/></td><td width="13"><IMG src="images/b_see_topright.gif"  alt=""/></td></tr><tr><td background="images/b_see_left.gif"><img src="images/b_see_left.gif" alt="" /></td><td class="seealso"><h3><b>Next Steps</b></h3>
<p class="p1b"><a onclick="javascript:doLink('CreateBuildScript');" href="CreateBuildScript.htm" >Create Build Script</a></p>
</td><td background="images/b_see_right.gif"><img src="images/b_see_right.gif" alt="" /></td></tr>
<tr><td><img src="images/b_see_bottomleft.gif"  alt=""/></td><td class="seealso_bottom"><img src="images/clear.gif"  alt=""/></td><td><img src="images/b_see_bottomright.gif"  alt=""/></td></tr></tbody></table></div><!-- end left column see also area -->
                        </div>
                        <!-- end left column see also area -->
                    </div>
                </td>
                <!-- end left column with navigation -->
                <!-- start center content area -->
                <td>
                    <table cellspacing="0" cellpadding="0" width="100%" border="0">
                        <tbody>
                            <tr>
                                <td>
                                    <img src="images/b_topleft.gif" alt="" /></td>
                                <td background="images/b_top.gif">
                                    <img height="15" src="images/b_top.gif" width="300" alt="" /></td>
                                <td>
                                    <img src="images/b_topright.gif" alt="" /></td>
                            </tr>
                            <tr>
                                <td background="images/b_left.gif">
                                    <img src="images/b_left.gif" alt="" /></td>
                                <!-- Start XSL3 -->
                                <td id="XSL3" width="100%" bgcolor="#ffffff">
                                    <div style="height: 280pt" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:some-prefix="some-uri"
                                        xmlns:msxml="urn:schemas-microsoft-com:xslt" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                                        xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-10-13T22:49:49"
                                        xmlns:mstns="http://tempuri.org/XMLSchema.xsd">
                                        <table cellspacing="0" cellpadding="0" width="100%" border="0">
                                            <tbody>
                                                <tr>
                                                    <td width="70">
                                                        <img height="61" alt="workstreams icon" src="images/i_workstreams.gif" width="61"
                                                            border="0" /></td>
                                                    <td>

                                                        <p class="title2">
                                                            Analyze Changes
                                                             
                                                        </p>
                                                        <p class="p1">
                                                            <img style="margin-top: -6pt; float: left" src="images/i_role_2.gif"/>
                                                            <strong></strong></p>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                        <p class="title3">
                                            Activity:</p>
                                        <p class="title2">
                                            Analyze Changes</p>
                                        <div style="margin-top: 12px">
                                            <table id="Table1" cellspacing="0" cellpadding="0" border="0">
                                                <tbody>
                                                    <tr>
                                                        <td>
                                                            <img class="small_icons" height="35" alt="role icon" src="images/i_role_2.gif" width="35" /></td>
                                                        <td>
                                                            <img height="1" src="images/clear.gif" width="8" alt="" /></td>
                                                        <td>
                                                            <table>
                                                                <tbody>
    <tr><td class="p1c"><a onclick="javascript:doLink('DatabaseAdministrator');" href="DatabaseAdministrator.htm">Database Administrator</a></td></tr>

                                                                </tbody>
                                                            </table>
                                                        </td>
                                                        <td><img height="1" src="images/clear.gif" width="20"/></td><td><img class="small_icons" height="35" alt="workstream icon" src="images/i_workstreams_2.gif" width="35"/></td><td><img height="1" src="images/clear.gif" width="8"/></td><td><p class="p1c"><a onclick="javascript:doLink('DeployaDatabaseProject');" href="DeployaDatabaseProject.htm">Deploy a Database Project</a></p></td>

                                                        
							
                                                        <td>
                                                            <img height="1" src="images/clear.gif" width="20" alt="" /></td>
                                                        <td>
                                                            <img height="1" src="images/clear.gif" width="14" alt="" /></td>
                                                    </tr>
                                                </tbody>
                                            </table>
                                        </div>
                                        <div class="raci">
                                            <table cellspacing="0" cellpadding="0" border="0">
                                                <tbody>
                                                    <tr>
                                                        <td width="2" bgcolor="#5f7cb0">
                                                            <img src="images/clear.gif" alt="" /></td>
                                                        <td width="4">
                                                            <img src="images/clear.gif" alt="" /></td>
                                                        <td>
                                                            <p class="h7">
                                                                Participating Roles</p>
                                                            <p class="p1b">Responsible:</p>
<p class="p1a"><strong><a onclick="javascript:doLink('DatabaseAdministrator');"  href="DatabaseAdministrator.htm">Database Administrator</a></strong></p>

                                                                </td></tr></tbody></table></div>
                                    <h3>
                                            <!-- <a onclick="doExpand(overview11, expand); toggleOverviewOn(overview11);" href="#">
                                                <img src="images/expando_closed.gif" border="0" name="expand">
                                               --> Overview <!-- </a> -->
                                    </h3>
                                    <div id="overview11" style=" margin: 0px 0px 0px 15px">
                                        <p class="p1">
                                            It is important for the database administrator to understand what exactly is the scope of changes that are about to be deployed to the database server. The database administrator can determine this by both looking at the source control change history since last deployment as well as doing a schema compare between the project and live database.</p>
                                    </div>
                                    <h1>
                                        Entry Criteria</h1>
                                        
					                <ul class="bodyitem_unit">
                                        <li class="bodyitem"><b>The database unit tests are complete and, if applicable, bugs are fixed.</b><br/>
                                             </li>
</ul>
                                    <p class="p1">
                                        <b></b></p>
                                    <ul class="bodyitem_unit">
                                        
                                    </ul>
                                    <h1>Sub-Activities</h1>
                                    <table cellspacing="0" cellpadding="3" width="100%" border="0">
                                        <tbody>
                                            <tr>
                                                <td colspan="3">
                                                    <img height="12" src="images/clear.gif" width="1"/></td>
                                            </tr>
                                            <tr><td width="36"><p class="step2">1</p></td><td width="20%"><p class="p1a">Review Source Control Change History Since Last Deployment</p></td><td><ul class="tableitem_unit"><li class="tableitem">Use the source control history to view all changes that have occurred in the database project since last deployment.</li><li class="tableitem">Contact specific developers about changes that you were not aware of and want to understand further prior to deployment.</li></ul><div style="margin: -4px 0px 6px"><img height="1" src="images/rule1.gif" width="100%"/></div></td></tr>
<tr><td width="36"><p class="step2">2</p></td><td width="20%"><p class="p1a">Use Schema Compare to Analyze Differences Between the Project and the Target Server</p></td><td><ul class="tableitem_unit"><li class="tableitem">Create a schema comparison session to compare the database project to the target server.</li><li class="tableitem">Analyze all differences found to ensure they are what you expected.</li></ul><div style="margin: -4px 0px 6px"><img height="1" src="images/rule1.gif" width="100%"/></div></td></tr>
<tr><td width="36"><p class="step2">3</p></td><td width="20%"><p class="p1a">Review the Refactoring Log Files</p></td><td><ul class="tableitem_unit"><li class="tableitem">Review the refactoring log files associated with the database project to understand all the database refactorings that have occurred since the last database deployment.</li></ul><div style="margin: -4px 0px 6px"><img height="1" src="images/rule1.gif" width="100%"/></div></td></tr>

                                        </tbody>
                                    </table>
                                    <h1>Exit Criteria</h1>
                                    <table cellspacing="0" cellpadding="0" width="100%" border="0">
                                        <tbody>
                                           <tr><td width="28"><img src="images/check.gif" alt=""/></td><td><p class="p1"><b>The scope of changes made to the database are analyzed and understood.</b></p></td></tr>

                                        </tbody>
                                    </table>
                                    </div>
                                </td>
                                <!-- End XSL3 -->
                                <!--  END CENTER ************************* -->
                                <td background="images/b_right.gif">
                                    <img src="images/b_right.gif" alt="" /></td>
                            </tr>
                            <tr>
                                <td>
                                    <img src="images/b_bottomleft.gif" alt="" /></td>
                                <td background="images/b_bottom.gif">
                                    <img src="images/b_bottom.gif" alt="" /></td>
                                <td>
                                    <img src="images/b_bottomright.gif" alt="" /></td>
                            </tr>
                        </tbody>
                    </table>
                    <!-- footer -->

                    <script>doFooter()</script>

                    <img height="10" src="images/clear.gif" width="1" alt="" />
                    <center>
                        <p class="p1a">
                            <a href="EULA/_EULA.txt">© 2005-2007 Microsoft Corporation. All rights reserved.</a></p>
                    </center>
                    <center>
                        <p class="p1a">
                            MSF for Agile Software Development 4.2</p>
                    </center>
                    <img height="20" src="images/clear.gif" width="1" alt="" />
                    <!-- end footer -->
                </td>
                <!-- endcenter content area -->
                <!-- start right margin -->
                <td width="20">
                    <img height="1" src="images/clear.gif" width="12" alt="" /></td>
                <!-- end left margin -->
            </tr>
        </tbody>
    </table>
    <!-- end main body table -->

    <script language="JScript" src="Code/Iceberg.js" defer="true" type="text/JScript"></script>

</body>
</html>
